FO_PtLocations_RoomBed
This table is referenced with expanded location information is needed for collection purposes. The predefined codes allow a user to only see valid room / bed entries for a specific PTLocCode.
| Field | Type | Notes |
|---|---|---|
|
Pt_Loc_RoomBed_ID |
int |
ID field, a counter. Unique |
|
PtLocCode |
varchar(50) |
Patient location code. Enter a valid patient location code. |
|
FacilityID |
varchar(50) |
Default facility ID for location. Enter a valid facility ID. |
|
RoomBedCode |
varchar(50) |
Enter code for room and bed. |
|
RoomCode |
varchar(50) |
Enter code for room. |
|
BedCode |
varchar(50) |
Enter code for bed. |
|
RestrictionCodes |
varchar(255) |
*** NEED DEFINITION *** |
|
Notes |
varchar(MAX) |
Informational |